<?php
$osc_id_str = $route->bodyParams['osc_id_str'];

$sql = "SELECT *,FROM_UNIXTIME(oct_start_time,'%H:%i:%s') as class_time_date,DAYOFWEEK(FROM_UNIXTIME(oct_start_time)) as week,FROM_UNIXTIME(oct_start_time,'%Y-%m-%d %H:%i:%s') as class_start_time,FROM_UNIXTIME(oct_end_time,'%Y-%m-%d %H:%i:%s') as class_end_time  FROM art_organization_erp.v_art_class_time_room where osc_id in ($osc_id_str) group by class_time_date,osc_id,week";

$re=$db->mysqlDB->query($sql);

$response->responseData(true, $re);